1. Load profile
Enter each appliance. Day hours are served directly by PV; night hours are served from the battery. Startup W is the per-unit surge (leave 0 for no surge).
| Appliance | Power (W) | Units | Day h | Night h | Startup (W) | Wh/day |
|---|
2. Design parameters
3. Equipment and capex assumptions (₦)
Prices are editable placeholders. Replace them with your current supplier quotes.
4. Revenue and financing
LCOE is calculated in real (constant ₦) terms using the real discount rate. Cash flows, NPV and IRR are nominal, using inflation and tariff escalation. Tax (if set) uses 10-year straight-line depreciation on capex, with tax losses carried forward. DSCR is measured before battery and inverter replacements, which are assumed to be funded from a reserve.
Customer tiers and revenue model
In tier mode the tiers set the customer count, energy sales and revenue; the single tariff and the share-sold field are ignored. Sales are capped at the designed supply, and customers connect gradually over the ramp period. Collection rate applies to energy and fixed charges. Connection fees are received in year 0 and reduce the equity needed. Tariffs are in year-0 prices and escalate with the tariff escalation rate.
| Tier | Customers | kWh/customer/month | Tariff (₦/kWh) | Fixed (₦/month) | Connection fee (₦) |
|---|
System sizing
Economics
Capex split
Cumulative cash flow (nominal)
LCOE vs tariff vs diesel
Capex breakdown
LCOE sensitivity (₦/kWh, real)
Tariff sensitivity
Scenario comparison
Change inputs, then pin the result as A or B to compare options side by side (for example LiFePO₄ against AGM).
Sensitivity: equity NPV and IRR at ±20%
Income statement (nominal)
Book depreciation is straight-line over 10 years (or project life if shorter). Replacements are expensed, as in the cash flow. Tax is the cash tax from the model.
Balance sheet (nominal)
All free cash after debt service is paid out to equity each year, so cash is nil. Equity includes the grant, connection fees and retained earnings, net of distributions.